package com.ecoolex.discount.sales.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class DiscountOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public DiscountOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DiscountOrderExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public DiscountOrderExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        DiscountOrderExample example = new DiscountOrderExample();
        return example.createCriteria();
    }

    public DiscountOrderExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public DiscountOrderExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public DiscountOrderExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public DiscountOrderExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public DiscountOrderExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("discountorder.OrderId is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("discountorder.OrderId is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(Integer value) {
            addCriterion("discountorder.OrderId =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(Integer value) {
            addCriterion("discountorder.OrderId <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(Integer value) {
            addCriterion("discountorder.OrderId >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountorder.OrderId >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(Integer value) {
            addCriterion("discountorder.OrderId <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(Integer value) {
            addCriterion("discountorder.OrderId <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<Integer> values) {
            addCriterion("discountorder.OrderId in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<Integer> values) {
            addCriterion("discountorder.OrderId not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.OrderId between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.OrderId not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("discountorder.OrderNo is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("discountorder.OrderNo is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("discountorder.OrderNo =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderNo = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("discountorder.OrderNo <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderNo <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("discountorder.OrderNo >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderNo > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("discountorder.OrderNo >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderNo >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("discountorder.OrderNo <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderNo < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("discountorder.OrderNo <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderNo <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("discountorder.OrderNo like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("discountorder.OrderNo not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("discountorder.OrderNo in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("discountorder.OrderNo not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("discountorder.OrderNo between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("discountorder.OrderNo not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("discountorder.UserId is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("discountorder.UserId is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Integer value) {
            addCriterion("discountorder.UserId =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UserId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Integer value) {
            addCriterion("discountorder.UserId <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UserId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Integer value) {
            addCriterion("discountorder.UserId >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UserId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountorder.UserId >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UserId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Integer value) {
            addCriterion("discountorder.UserId <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UserId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("discountorder.UserId <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UserId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Integer> values) {
            addCriterion("discountorder.UserId in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Integer> values) {
            addCriterion("discountorder.UserId not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.UserId between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.UserId not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andMobileNumberIsNull() {
            addCriterion("discountorder.MobileNumber is null");
            return (Criteria) this;
        }

        public Criteria andMobileNumberIsNotNull() {
            addCriterion("discountorder.MobileNumber is not null");
            return (Criteria) this;
        }

        public Criteria andMobileNumberEqualTo(String value) {
            addCriterion("discountorder.MobileNumber =", value, "mobileNumber");
            return (Criteria) this;
        }

        public Criteria andMobileNumberEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.MobileNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMobileNumberNotEqualTo(String value) {
            addCriterion("discountorder.MobileNumber <>", value, "mobileNumber");
            return (Criteria) this;
        }

        public Criteria andMobileNumberNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.MobileNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMobileNumberGreaterThan(String value) {
            addCriterion("discountorder.MobileNumber >", value, "mobileNumber");
            return (Criteria) this;
        }

        public Criteria andMobileNumberGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.MobileNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMobileNumberGreaterThanOrEqualTo(String value) {
            addCriterion("discountorder.MobileNumber >=", value, "mobileNumber");
            return (Criteria) this;
        }

        public Criteria andMobileNumberGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.MobileNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMobileNumberLessThan(String value) {
            addCriterion("discountorder.MobileNumber <", value, "mobileNumber");
            return (Criteria) this;
        }

        public Criteria andMobileNumberLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.MobileNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMobileNumberLessThanOrEqualTo(String value) {
            addCriterion("discountorder.MobileNumber <=", value, "mobileNumber");
            return (Criteria) this;
        }

        public Criteria andMobileNumberLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.MobileNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMobileNumberLike(String value) {
            addCriterion("discountorder.MobileNumber like", value, "mobileNumber");
            return (Criteria) this;
        }

        public Criteria andMobileNumberNotLike(String value) {
            addCriterion("discountorder.MobileNumber not like", value, "mobileNumber");
            return (Criteria) this;
        }

        public Criteria andMobileNumberIn(List<String> values) {
            addCriterion("discountorder.MobileNumber in", values, "mobileNumber");
            return (Criteria) this;
        }

        public Criteria andMobileNumberNotIn(List<String> values) {
            addCriterion("discountorder.MobileNumber not in", values, "mobileNumber");
            return (Criteria) this;
        }

        public Criteria andMobileNumberBetween(String value1, String value2) {
            addCriterion("discountorder.MobileNumber between", value1, value2, "mobileNumber");
            return (Criteria) this;
        }

        public Criteria andMobileNumberNotBetween(String value1, String value2) {
            addCriterion("discountorder.MobileNumber not between", value1, value2, "mobileNumber");
            return (Criteria) this;
        }

        public Criteria andRegionTypeIsNull() {
            addCriterion("discountorder.RegionType is null");
            return (Criteria) this;
        }

        public Criteria andRegionTypeIsNotNull() {
            addCriterion("discountorder.RegionType is not null");
            return (Criteria) this;
        }

        public Criteria andRegionTypeEqualTo(Integer value) {
            addCriterion("discountorder.RegionType =", value, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RegionType = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRegionTypeNotEqualTo(Integer value) {
            addCriterion("discountorder.RegionType <>", value, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RegionType <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRegionTypeGreaterThan(Integer value) {
            addCriterion("discountorder.RegionType >", value, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RegionType > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRegionTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountorder.RegionType >=", value, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RegionType >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRegionTypeLessThan(Integer value) {
            addCriterion("discountorder.RegionType <", value, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RegionType < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRegionTypeLessThanOrEqualTo(Integer value) {
            addCriterion("discountorder.RegionType <=", value, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RegionType <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRegionTypeIn(List<Integer> values) {
            addCriterion("discountorder.RegionType in", values, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeNotIn(List<Integer> values) {
            addCriterion("discountorder.RegionType not in", values, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.RegionType between", value1, value2, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.RegionType not between", value1, value2, "regionType");
            return (Criteria) this;
        }

        public Criteria andBrandIdIsNull() {
            addCriterion("discountorder.BrandId is null");
            return (Criteria) this;
        }

        public Criteria andBrandIdIsNotNull() {
            addCriterion("discountorder.BrandId is not null");
            return (Criteria) this;
        }

        public Criteria andBrandIdEqualTo(Integer value) {
            addCriterion("discountorder.BrandId =", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BrandId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandIdNotEqualTo(Integer value) {
            addCriterion("discountorder.BrandId <>", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BrandId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThan(Integer value) {
            addCriterion("discountorder.BrandId >", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BrandId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountorder.BrandId >=", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BrandId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThan(Integer value) {
            addCriterion("discountorder.BrandId <", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BrandId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThanOrEqualTo(Integer value) {
            addCriterion("discountorder.BrandId <=", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BrandId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandIdIn(List<Integer> values) {
            addCriterion("discountorder.BrandId in", values, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotIn(List<Integer> values) {
            addCriterion("discountorder.BrandId not in", values, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.BrandId between", value1, value2, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.BrandId not between", value1, value2, "brandId");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNull() {
            addCriterion("discountorder.ProductId is null");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNotNull() {
            addCriterion("discountorder.ProductId is not null");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualTo(Integer value) {
            addCriterion("discountorder.ProductId =", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProductId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualTo(Integer value) {
            addCriterion("discountorder.ProductId <>", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProductId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThan(Integer value) {
            addCriterion("discountorder.ProductId >", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProductId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountorder.ProductId >=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProductId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdLessThan(Integer value) {
            addCriterion("discountorder.ProductId <", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProductId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualTo(Integer value) {
            addCriterion("discountorder.ProductId <=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProductId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdIn(List<Integer> values) {
            addCriterion("discountorder.ProductId in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotIn(List<Integer> values) {
            addCriterion("discountorder.ProductId not in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.ProductId between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.ProductId not between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andDiscountModeIsNull() {
            addCriterion("discountorder.DiscountMode is null");
            return (Criteria) this;
        }

        public Criteria andDiscountModeIsNotNull() {
            addCriterion("discountorder.DiscountMode is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountModeEqualTo(Integer value) {
            addCriterion("discountorder.DiscountMode =", value, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.DiscountMode = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountModeNotEqualTo(Integer value) {
            addCriterion("discountorder.DiscountMode <>", value, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.DiscountMode <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountModeGreaterThan(Integer value) {
            addCriterion("discountorder.DiscountMode >", value, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.DiscountMode > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountModeGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountorder.DiscountMode >=", value, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.DiscountMode >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountModeLessThan(Integer value) {
            addCriterion("discountorder.DiscountMode <", value, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.DiscountMode < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountModeLessThanOrEqualTo(Integer value) {
            addCriterion("discountorder.DiscountMode <=", value, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.DiscountMode <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountModeIn(List<Integer> values) {
            addCriterion("discountorder.DiscountMode in", values, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeNotIn(List<Integer> values) {
            addCriterion("discountorder.DiscountMode not in", values, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.DiscountMode between", value1, value2, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeNotBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.DiscountMode not between", value1, value2, "discountMode");
            return (Criteria) this;
        }

        public Criteria andServiceTypeIsNull() {
            addCriterion("discountorder.ServiceType is null");
            return (Criteria) this;
        }

        public Criteria andServiceTypeIsNotNull() {
            addCriterion("discountorder.ServiceType is not null");
            return (Criteria) this;
        }

        public Criteria andServiceTypeEqualTo(Integer value) {
            addCriterion("discountorder.ServiceType =", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ServiceType = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceTypeNotEqualTo(Integer value) {
            addCriterion("discountorder.ServiceType <>", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ServiceType <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceTypeGreaterThan(Integer value) {
            addCriterion("discountorder.ServiceType >", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ServiceType > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountorder.ServiceType >=", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ServiceType >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceTypeLessThan(Integer value) {
            addCriterion("discountorder.ServiceType <", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ServiceType < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceTypeLessThanOrEqualTo(Integer value) {
            addCriterion("discountorder.ServiceType <=", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ServiceType <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceTypeIn(List<Integer> values) {
            addCriterion("discountorder.ServiceType in", values, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeNotIn(List<Integer> values) {
            addCriterion("discountorder.ServiceType not in", values, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.ServiceType between", value1, value2, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.ServiceType not between", value1, value2, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdIsNull() {
            addCriterion("discountorder.ServiceDataId is null");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdIsNotNull() {
            addCriterion("discountorder.ServiceDataId is not null");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdEqualTo(String value) {
            addCriterion("discountorder.ServiceDataId =", value, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ServiceDataId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDataIdNotEqualTo(String value) {
            addCriterion("discountorder.ServiceDataId <>", value, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ServiceDataId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDataIdGreaterThan(String value) {
            addCriterion("discountorder.ServiceDataId >", value, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ServiceDataId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDataIdGreaterThanOrEqualTo(String value) {
            addCriterion("discountorder.ServiceDataId >=", value, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ServiceDataId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDataIdLessThan(String value) {
            addCriterion("discountorder.ServiceDataId <", value, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ServiceDataId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDataIdLessThanOrEqualTo(String value) {
            addCriterion("discountorder.ServiceDataId <=", value, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ServiceDataId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDataIdLike(String value) {
            addCriterion("discountorder.ServiceDataId like", value, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdNotLike(String value) {
            addCriterion("discountorder.ServiceDataId not like", value, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdIn(List<String> values) {
            addCriterion("discountorder.ServiceDataId in", values, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdNotIn(List<String> values) {
            addCriterion("discountorder.ServiceDataId not in", values, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdBetween(String value1, String value2) {
            addCriterion("discountorder.ServiceDataId between", value1, value2, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdNotBetween(String value1, String value2) {
            addCriterion("discountorder.ServiceDataId not between", value1, value2, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountIsNull() {
            addCriterion("discountorder.RechargeAccount is null");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountIsNotNull() {
            addCriterion("discountorder.RechargeAccount is not null");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountEqualTo(String value) {
            addCriterion("discountorder.RechargeAccount =", value, "rechargeAccount");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RechargeAccount = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRechargeAccountNotEqualTo(String value) {
            addCriterion("discountorder.RechargeAccount <>", value, "rechargeAccount");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RechargeAccount <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRechargeAccountGreaterThan(String value) {
            addCriterion("discountorder.RechargeAccount >", value, "rechargeAccount");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RechargeAccount > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRechargeAccountGreaterThanOrEqualTo(String value) {
            addCriterion("discountorder.RechargeAccount >=", value, "rechargeAccount");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RechargeAccount >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRechargeAccountLessThan(String value) {
            addCriterion("discountorder.RechargeAccount <", value, "rechargeAccount");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RechargeAccount < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRechargeAccountLessThanOrEqualTo(String value) {
            addCriterion("discountorder.RechargeAccount <=", value, "rechargeAccount");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RechargeAccount <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRechargeAccountLike(String value) {
            addCriterion("discountorder.RechargeAccount like", value, "rechargeAccount");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountNotLike(String value) {
            addCriterion("discountorder.RechargeAccount not like", value, "rechargeAccount");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountIn(List<String> values) {
            addCriterion("discountorder.RechargeAccount in", values, "rechargeAccount");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountNotIn(List<String> values) {
            addCriterion("discountorder.RechargeAccount not in", values, "rechargeAccount");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountBetween(String value1, String value2) {
            addCriterion("discountorder.RechargeAccount between", value1, value2, "rechargeAccount");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountNotBetween(String value1, String value2) {
            addCriterion("discountorder.RechargeAccount not between", value1, value2, "rechargeAccount");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasIsNull() {
            addCriterion("discountorder.RechargeAccountAlias is null");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasIsNotNull() {
            addCriterion("discountorder.RechargeAccountAlias is not null");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasEqualTo(String value) {
            addCriterion("discountorder.RechargeAccountAlias =", value, "rechargeAccountAlias");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RechargeAccountAlias = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasNotEqualTo(String value) {
            addCriterion("discountorder.RechargeAccountAlias <>", value, "rechargeAccountAlias");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RechargeAccountAlias <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasGreaterThan(String value) {
            addCriterion("discountorder.RechargeAccountAlias >", value, "rechargeAccountAlias");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RechargeAccountAlias > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasGreaterThanOrEqualTo(String value) {
            addCriterion("discountorder.RechargeAccountAlias >=", value, "rechargeAccountAlias");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RechargeAccountAlias >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasLessThan(String value) {
            addCriterion("discountorder.RechargeAccountAlias <", value, "rechargeAccountAlias");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RechargeAccountAlias < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasLessThanOrEqualTo(String value) {
            addCriterion("discountorder.RechargeAccountAlias <=", value, "rechargeAccountAlias");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RechargeAccountAlias <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasLike(String value) {
            addCriterion("discountorder.RechargeAccountAlias like", value, "rechargeAccountAlias");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasNotLike(String value) {
            addCriterion("discountorder.RechargeAccountAlias not like", value, "rechargeAccountAlias");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasIn(List<String> values) {
            addCriterion("discountorder.RechargeAccountAlias in", values, "rechargeAccountAlias");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasNotIn(List<String> values) {
            addCriterion("discountorder.RechargeAccountAlias not in", values, "rechargeAccountAlias");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasBetween(String value1, String value2) {
            addCriterion("discountorder.RechargeAccountAlias between", value1, value2, "rechargeAccountAlias");
            return (Criteria) this;
        }

        public Criteria andRechargeAccountAliasNotBetween(String value1, String value2) {
            addCriterion("discountorder.RechargeAccountAlias not between", value1, value2, "rechargeAccountAlias");
            return (Criteria) this;
        }

        public Criteria andBuyNumberIsNull() {
            addCriterion("discountorder.BuyNumber is null");
            return (Criteria) this;
        }

        public Criteria andBuyNumberIsNotNull() {
            addCriterion("discountorder.BuyNumber is not null");
            return (Criteria) this;
        }

        public Criteria andBuyNumberEqualTo(Integer value) {
            addCriterion("discountorder.BuyNumber =", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberNotEqualTo(Integer value) {
            addCriterion("discountorder.BuyNumber <>", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberGreaterThan(Integer value) {
            addCriterion("discountorder.BuyNumber >", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountorder.BuyNumber >=", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberLessThan(Integer value) {
            addCriterion("discountorder.BuyNumber <", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberLessThanOrEqualTo(Integer value) {
            addCriterion("discountorder.BuyNumber <=", value, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyNumberIn(List<Integer> values) {
            addCriterion("discountorder.BuyNumber in", values, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberNotIn(List<Integer> values) {
            addCriterion("discountorder.BuyNumber not in", values, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.BuyNumber between", value1, value2, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.BuyNumber not between", value1, value2, "buyNumber");
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceIsNull() {
            addCriterion("discountorder.BuyCounterPrice is null");
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceIsNotNull() {
            addCriterion("discountorder.BuyCounterPrice is not null");
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceEqualTo(BigDecimal value) {
            addCriterion("discountorder.BuyCounterPrice =", value, "buyCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyCounterPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceNotEqualTo(BigDecimal value) {
            addCriterion("discountorder.BuyCounterPrice <>", value, "buyCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyCounterPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceGreaterThan(BigDecimal value) {
            addCriterion("discountorder.BuyCounterPrice >", value, "buyCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyCounterPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discountorder.BuyCounterPrice >=", value, "buyCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyCounterPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceLessThan(BigDecimal value) {
            addCriterion("discountorder.BuyCounterPrice <", value, "buyCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyCounterPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discountorder.BuyCounterPrice <=", value, "buyCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyCounterPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceIn(List<BigDecimal> values) {
            addCriterion("discountorder.BuyCounterPrice in", values, "buyCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceNotIn(List<BigDecimal> values) {
            addCriterion("discountorder.BuyCounterPrice not in", values, "buyCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountorder.BuyCounterPrice between", value1, value2, "buyCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyCounterPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountorder.BuyCounterPrice not between", value1, value2, "buyCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceIsNull() {
            addCriterion("discountorder.BuyTotalCounterPrice is null");
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceIsNotNull() {
            addCriterion("discountorder.BuyTotalCounterPrice is not null");
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceEqualTo(BigDecimal value) {
            addCriterion("discountorder.BuyTotalCounterPrice =", value, "buyTotalCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyTotalCounterPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceNotEqualTo(BigDecimal value) {
            addCriterion("discountorder.BuyTotalCounterPrice <>", value, "buyTotalCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyTotalCounterPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceGreaterThan(BigDecimal value) {
            addCriterion("discountorder.BuyTotalCounterPrice >", value, "buyTotalCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyTotalCounterPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discountorder.BuyTotalCounterPrice >=", value, "buyTotalCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyTotalCounterPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceLessThan(BigDecimal value) {
            addCriterion("discountorder.BuyTotalCounterPrice <", value, "buyTotalCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyTotalCounterPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discountorder.BuyTotalCounterPrice <=", value, "buyTotalCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.BuyTotalCounterPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceIn(List<BigDecimal> values) {
            addCriterion("discountorder.BuyTotalCounterPrice in", values, "buyTotalCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceNotIn(List<BigDecimal> values) {
            addCriterion("discountorder.BuyTotalCounterPrice not in", values, "buyTotalCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountorder.BuyTotalCounterPrice between", value1, value2, "buyTotalCounterPrice");
            return (Criteria) this;
        }

        public Criteria andBuyTotalCounterPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountorder.BuyTotalCounterPrice not between", value1, value2, "buyTotalCounterPrice");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeIsNull() {
            addCriterion("discountorder.CurrencyType is null");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeIsNotNull() {
            addCriterion("discountorder.CurrencyType is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeEqualTo(String value) {
            addCriterion("discountorder.CurrencyType =", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CurrencyType = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotEqualTo(String value) {
            addCriterion("discountorder.CurrencyType <>", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CurrencyType <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThan(String value) {
            addCriterion("discountorder.CurrencyType >", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CurrencyType > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThanOrEqualTo(String value) {
            addCriterion("discountorder.CurrencyType >=", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CurrencyType >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThan(String value) {
            addCriterion("discountorder.CurrencyType <", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CurrencyType < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThanOrEqualTo(String value) {
            addCriterion("discountorder.CurrencyType <=", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CurrencyType <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLike(String value) {
            addCriterion("discountorder.CurrencyType like", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotLike(String value) {
            addCriterion("discountorder.CurrencyType not like", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeIn(List<String> values) {
            addCriterion("discountorder.CurrencyType in", values, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotIn(List<String> values) {
            addCriterion("discountorder.CurrencyType not in", values, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeBetween(String value1, String value2) {
            addCriterion("discountorder.CurrencyType between", value1, value2, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotBetween(String value1, String value2) {
            addCriterion("discountorder.CurrencyType not between", value1, value2, "currencyType");
            return (Criteria) this;
        }

        public Criteria andRetailPriceIsNull() {
            addCriterion("discountorder.RetailPrice is null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceIsNotNull() {
            addCriterion("discountorder.RetailPrice is not null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceEqualTo(BigDecimal value) {
            addCriterion("discountorder.RetailPrice =", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RetailPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotEqualTo(BigDecimal value) {
            addCriterion("discountorder.RetailPrice <>", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RetailPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThan(BigDecimal value) {
            addCriterion("discountorder.RetailPrice >", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RetailPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discountorder.RetailPrice >=", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RetailPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThan(BigDecimal value) {
            addCriterion("discountorder.RetailPrice <", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RetailPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discountorder.RetailPrice <=", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RetailPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceIn(List<BigDecimal> values) {
            addCriterion("discountorder.RetailPrice in", values, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotIn(List<BigDecimal> values) {
            addCriterion("discountorder.RetailPrice not in", values, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountorder.RetailPrice between", value1, value2, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountorder.RetailPrice not between", value1, value2, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceIsNull() {
            addCriterion("discountorder.TotalRetailPrice is null");
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceIsNotNull() {
            addCriterion("discountorder.TotalRetailPrice is not null");
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceEqualTo(BigDecimal value) {
            addCriterion("discountorder.TotalRetailPrice =", value, "totalRetailPrice");
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.TotalRetailPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceNotEqualTo(BigDecimal value) {
            addCriterion("discountorder.TotalRetailPrice <>", value, "totalRetailPrice");
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.TotalRetailPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceGreaterThan(BigDecimal value) {
            addCriterion("discountorder.TotalRetailPrice >", value, "totalRetailPrice");
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.TotalRetailPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discountorder.TotalRetailPrice >=", value, "totalRetailPrice");
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.TotalRetailPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceLessThan(BigDecimal value) {
            addCriterion("discountorder.TotalRetailPrice <", value, "totalRetailPrice");
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.TotalRetailPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discountorder.TotalRetailPrice <=", value, "totalRetailPrice");
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.TotalRetailPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceIn(List<BigDecimal> values) {
            addCriterion("discountorder.TotalRetailPrice in", values, "totalRetailPrice");
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceNotIn(List<BigDecimal> values) {
            addCriterion("discountorder.TotalRetailPrice not in", values, "totalRetailPrice");
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountorder.TotalRetailPrice between", value1, value2, "totalRetailPrice");
            return (Criteria) this;
        }

        public Criteria andTotalRetailPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountorder.TotalRetailPrice not between", value1, value2, "totalRetailPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceIsNull() {
            addCriterion("discountorder.TotalPrice is null");
            return (Criteria) this;
        }

        public Criteria andTotalPriceIsNotNull() {
            addCriterion("discountorder.TotalPrice is not null");
            return (Criteria) this;
        }

        public Criteria andTotalPriceEqualTo(BigDecimal value) {
            addCriterion("discountorder.TotalPrice =", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.TotalPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotEqualTo(BigDecimal value) {
            addCriterion("discountorder.TotalPrice <>", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.TotalPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThan(BigDecimal value) {
            addCriterion("discountorder.TotalPrice >", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.TotalPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discountorder.TotalPrice >=", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.TotalPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThan(BigDecimal value) {
            addCriterion("discountorder.TotalPrice <", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.TotalPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discountorder.TotalPrice <=", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.TotalPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceIn(List<BigDecimal> values) {
            addCriterion("discountorder.TotalPrice in", values, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotIn(List<BigDecimal> values) {
            addCriterion("discountorder.TotalPrice not in", values, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountorder.TotalPrice between", value1, value2, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountorder.TotalPrice not between", value1, value2, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceIsNull() {
            addCriterion("discountorder.DiscountPrice is null");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceIsNotNull() {
            addCriterion("discountorder.DiscountPrice is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceEqualTo(BigDecimal value) {
            addCriterion("discountorder.DiscountPrice =", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.DiscountPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountPriceNotEqualTo(BigDecimal value) {
            addCriterion("discountorder.DiscountPrice <>", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.DiscountPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountPriceGreaterThan(BigDecimal value) {
            addCriterion("discountorder.DiscountPrice >", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.DiscountPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discountorder.DiscountPrice >=", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.DiscountPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountPriceLessThan(BigDecimal value) {
            addCriterion("discountorder.DiscountPrice <", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.DiscountPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discountorder.DiscountPrice <=", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.DiscountPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountPriceIn(List<BigDecimal> values) {
            addCriterion("discountorder.DiscountPrice in", values, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceNotIn(List<BigDecimal> values) {
            addCriterion("discountorder.DiscountPrice not in", values, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountorder.DiscountPrice between", value1, value2, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountorder.DiscountPrice not between", value1, value2, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andShelfLifeIsNull() {
            addCriterion("discountorder.ShelfLife is null");
            return (Criteria) this;
        }

        public Criteria andShelfLifeIsNotNull() {
            addCriterion("discountorder.ShelfLife is not null");
            return (Criteria) this;
        }

        public Criteria andShelfLifeEqualTo(Date value) {
            addCriterion("discountorder.ShelfLife =", value, "shelfLife");
            return (Criteria) this;
        }

        public Criteria andShelfLifeEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ShelfLife = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeNotEqualTo(Date value) {
            addCriterion("discountorder.ShelfLife <>", value, "shelfLife");
            return (Criteria) this;
        }

        public Criteria andShelfLifeNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ShelfLife <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeGreaterThan(Date value) {
            addCriterion("discountorder.ShelfLife >", value, "shelfLife");
            return (Criteria) this;
        }

        public Criteria andShelfLifeGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ShelfLife > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeGreaterThanOrEqualTo(Date value) {
            addCriterion("discountorder.ShelfLife >=", value, "shelfLife");
            return (Criteria) this;
        }

        public Criteria andShelfLifeGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ShelfLife >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeLessThan(Date value) {
            addCriterion("discountorder.ShelfLife <", value, "shelfLife");
            return (Criteria) this;
        }

        public Criteria andShelfLifeLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ShelfLife < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeLessThanOrEqualTo(Date value) {
            addCriterion("discountorder.ShelfLife <=", value, "shelfLife");
            return (Criteria) this;
        }

        public Criteria andShelfLifeLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ShelfLife <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeIn(List<Date> values) {
            addCriterion("discountorder.ShelfLife in", values, "shelfLife");
            return (Criteria) this;
        }

        public Criteria andShelfLifeNotIn(List<Date> values) {
            addCriterion("discountorder.ShelfLife not in", values, "shelfLife");
            return (Criteria) this;
        }

        public Criteria andShelfLifeBetween(Date value1, Date value2) {
            addCriterion("discountorder.ShelfLife between", value1, value2, "shelfLife");
            return (Criteria) this;
        }

        public Criteria andShelfLifeNotBetween(Date value1, Date value2) {
            addCriterion("discountorder.ShelfLife not between", value1, value2, "shelfLife");
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeIsNull() {
            addCriterion("discountorder.FinalExpiretime is null");
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeIsNotNull() {
            addCriterion("discountorder.FinalExpiretime is not null");
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeEqualTo(Date value) {
            addCriterion("discountorder.FinalExpiretime =", value, "finalExpiretime");
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.FinalExpiretime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeNotEqualTo(Date value) {
            addCriterion("discountorder.FinalExpiretime <>", value, "finalExpiretime");
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.FinalExpiretime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeGreaterThan(Date value) {
            addCriterion("discountorder.FinalExpiretime >", value, "finalExpiretime");
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.FinalExpiretime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeGreaterThanOrEqualTo(Date value) {
            addCriterion("discountorder.FinalExpiretime >=", value, "finalExpiretime");
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.FinalExpiretime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeLessThan(Date value) {
            addCriterion("discountorder.FinalExpiretime <", value, "finalExpiretime");
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.FinalExpiretime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeLessThanOrEqualTo(Date value) {
            addCriterion("discountorder.FinalExpiretime <=", value, "finalExpiretime");
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.FinalExpiretime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeIn(List<Date> values) {
            addCriterion("discountorder.FinalExpiretime in", values, "finalExpiretime");
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeNotIn(List<Date> values) {
            addCriterion("discountorder.FinalExpiretime not in", values, "finalExpiretime");
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeBetween(Date value1, Date value2) {
            addCriterion("discountorder.FinalExpiretime between", value1, value2, "finalExpiretime");
            return (Criteria) this;
        }

        public Criteria andFinalExpiretimeNotBetween(Date value1, Date value2) {
            addCriterion("discountorder.FinalExpiretime not between", value1, value2, "finalExpiretime");
            return (Criteria) this;
        }

        public Criteria andPaymentChannelIsNull() {
            addCriterion("discountorder.PaymentChannel is null");
            return (Criteria) this;
        }

        public Criteria andPaymentChannelIsNotNull() {
            addCriterion("discountorder.PaymentChannel is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentChannelEqualTo(Integer value) {
            addCriterion("discountorder.PaymentChannel =", value, "paymentChannel");
            return (Criteria) this;
        }

        public Criteria andPaymentChannelEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentChannel = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentChannelNotEqualTo(Integer value) {
            addCriterion("discountorder.PaymentChannel <>", value, "paymentChannel");
            return (Criteria) this;
        }

        public Criteria andPaymentChannelNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentChannel <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentChannelGreaterThan(Integer value) {
            addCriterion("discountorder.PaymentChannel >", value, "paymentChannel");
            return (Criteria) this;
        }

        public Criteria andPaymentChannelGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentChannel > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentChannelGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountorder.PaymentChannel >=", value, "paymentChannel");
            return (Criteria) this;
        }

        public Criteria andPaymentChannelGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentChannel >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentChannelLessThan(Integer value) {
            addCriterion("discountorder.PaymentChannel <", value, "paymentChannel");
            return (Criteria) this;
        }

        public Criteria andPaymentChannelLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentChannel < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentChannelLessThanOrEqualTo(Integer value) {
            addCriterion("discountorder.PaymentChannel <=", value, "paymentChannel");
            return (Criteria) this;
        }

        public Criteria andPaymentChannelLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentChannel <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentChannelIn(List<Integer> values) {
            addCriterion("discountorder.PaymentChannel in", values, "paymentChannel");
            return (Criteria) this;
        }

        public Criteria andPaymentChannelNotIn(List<Integer> values) {
            addCriterion("discountorder.PaymentChannel not in", values, "paymentChannel");
            return (Criteria) this;
        }

        public Criteria andPaymentChannelBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.PaymentChannel between", value1, value2, "paymentChannel");
            return (Criteria) this;
        }

        public Criteria andPaymentChannelNotBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.PaymentChannel not between", value1, value2, "paymentChannel");
            return (Criteria) this;
        }

        public Criteria andPaymentNoIsNull() {
            addCriterion("discountorder.PaymentNo is null");
            return (Criteria) this;
        }

        public Criteria andPaymentNoIsNotNull() {
            addCriterion("discountorder.PaymentNo is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentNoEqualTo(String value) {
            addCriterion("discountorder.PaymentNo =", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentNo = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotEqualTo(String value) {
            addCriterion("discountorder.PaymentNo <>", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentNo <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoGreaterThan(String value) {
            addCriterion("discountorder.PaymentNo >", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentNo > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoGreaterThanOrEqualTo(String value) {
            addCriterion("discountorder.PaymentNo >=", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentNo >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoLessThan(String value) {
            addCriterion("discountorder.PaymentNo <", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentNo < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoLessThanOrEqualTo(String value) {
            addCriterion("discountorder.PaymentNo <=", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentNo <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoLike(String value) {
            addCriterion("discountorder.PaymentNo like", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotLike(String value) {
            addCriterion("discountorder.PaymentNo not like", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoIn(List<String> values) {
            addCriterion("discountorder.PaymentNo in", values, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotIn(List<String> values) {
            addCriterion("discountorder.PaymentNo not in", values, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoBetween(String value1, String value2) {
            addCriterion("discountorder.PaymentNo between", value1, value2, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotBetween(String value1, String value2) {
            addCriterion("discountorder.PaymentNo not between", value1, value2, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIsNull() {
            addCriterion("discountorder.PaymentTime is null");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIsNotNull() {
            addCriterion("discountorder.PaymentTime is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeEqualTo(Date value) {
            addCriterion("discountorder.PaymentTime =", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotEqualTo(Date value) {
            addCriterion("discountorder.PaymentTime <>", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThan(Date value) {
            addCriterion("discountorder.PaymentTime >", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("discountorder.PaymentTime >=", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThan(Date value) {
            addCriterion("discountorder.PaymentTime <", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThanOrEqualTo(Date value) {
            addCriterion("discountorder.PaymentTime <=", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIn(List<Date> values) {
            addCriterion("discountorder.PaymentTime in", values, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotIn(List<Date> values) {
            addCriterion("discountorder.PaymentTime not in", values, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeBetween(Date value1, Date value2) {
            addCriterion("discountorder.PaymentTime between", value1, value2, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotBetween(Date value1, Date value2) {
            addCriterion("discountorder.PaymentTime not between", value1, value2, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountIsNull() {
            addCriterion("discountorder.PaymentRMBAmount is null");
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountIsNotNull() {
            addCriterion("discountorder.PaymentRMBAmount is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountEqualTo(BigDecimal value) {
            addCriterion("discountorder.PaymentRMBAmount =", value, "paymentRMBAmount");
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentRMBAmount = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountNotEqualTo(BigDecimal value) {
            addCriterion("discountorder.PaymentRMBAmount <>", value, "paymentRMBAmount");
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentRMBAmount <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountGreaterThan(BigDecimal value) {
            addCriterion("discountorder.PaymentRMBAmount >", value, "paymentRMBAmount");
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentRMBAmount > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discountorder.PaymentRMBAmount >=", value, "paymentRMBAmount");
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentRMBAmount >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountLessThan(BigDecimal value) {
            addCriterion("discountorder.PaymentRMBAmount <", value, "paymentRMBAmount");
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentRMBAmount < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discountorder.PaymentRMBAmount <=", value, "paymentRMBAmount");
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.PaymentRMBAmount <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountIn(List<BigDecimal> values) {
            addCriterion("discountorder.PaymentRMBAmount in", values, "paymentRMBAmount");
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountNotIn(List<BigDecimal> values) {
            addCriterion("discountorder.PaymentRMBAmount not in", values, "paymentRMBAmount");
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountorder.PaymentRMBAmount between", value1, value2, "paymentRMBAmount");
            return (Criteria) this;
        }

        public Criteria andPaymentRMBAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountorder.PaymentRMBAmount not between", value1, value2, "paymentRMBAmount");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeIsNull() {
            addCriterion("discountorder.ConfirmReceiptTime is null");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeIsNotNull() {
            addCriterion("discountorder.ConfirmReceiptTime is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeEqualTo(Date value) {
            addCriterion("discountorder.ConfirmReceiptTime =", value, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ConfirmReceiptTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeNotEqualTo(Date value) {
            addCriterion("discountorder.ConfirmReceiptTime <>", value, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ConfirmReceiptTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeGreaterThan(Date value) {
            addCriterion("discountorder.ConfirmReceiptTime >", value, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ConfirmReceiptTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("discountorder.ConfirmReceiptTime >=", value, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ConfirmReceiptTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeLessThan(Date value) {
            addCriterion("discountorder.ConfirmReceiptTime <", value, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ConfirmReceiptTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeLessThanOrEqualTo(Date value) {
            addCriterion("discountorder.ConfirmReceiptTime <=", value, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ConfirmReceiptTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeIn(List<Date> values) {
            addCriterion("discountorder.ConfirmReceiptTime in", values, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeNotIn(List<Date> values) {
            addCriterion("discountorder.ConfirmReceiptTime not in", values, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeBetween(Date value1, Date value2) {
            addCriterion("discountorder.ConfirmReceiptTime between", value1, value2, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeNotBetween(Date value1, Date value2) {
            addCriterion("discountorder.ConfirmReceiptTime not between", value1, value2, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNull() {
            addCriterion("discountorder.OrderStatus is null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNotNull() {
            addCriterion("discountorder.OrderStatus is not null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusEqualTo(Integer value) {
            addCriterion("discountorder.OrderStatus =", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderStatus = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotEqualTo(Integer value) {
            addCriterion("discountorder.OrderStatus <>", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderStatus <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThan(Integer value) {
            addCriterion("discountorder.OrderStatus >", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderStatus > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountorder.OrderStatus >=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderStatus >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThan(Integer value) {
            addCriterion("discountorder.OrderStatus <", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderStatus < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThanOrEqualTo(Integer value) {
            addCriterion("discountorder.OrderStatus <=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.OrderStatus <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderStatusIn(List<Integer> values) {
            addCriterion("discountorder.OrderStatus in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotIn(List<Integer> values) {
            addCriterion("discountorder.OrderStatus not in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.OrderStatus between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.OrderStatus not between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andCancelStatusIsNull() {
            addCriterion("discountorder.CancelStatus is null");
            return (Criteria) this;
        }

        public Criteria andCancelStatusIsNotNull() {
            addCriterion("discountorder.CancelStatus is not null");
            return (Criteria) this;
        }

        public Criteria andCancelStatusEqualTo(Integer value) {
            addCriterion("discountorder.CancelStatus =", value, "cancelStatus");
            return (Criteria) this;
        }

        public Criteria andCancelStatusEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CancelStatus = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelStatusNotEqualTo(Integer value) {
            addCriterion("discountorder.CancelStatus <>", value, "cancelStatus");
            return (Criteria) this;
        }

        public Criteria andCancelStatusNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CancelStatus <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelStatusGreaterThan(Integer value) {
            addCriterion("discountorder.CancelStatus >", value, "cancelStatus");
            return (Criteria) this;
        }

        public Criteria andCancelStatusGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CancelStatus > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountorder.CancelStatus >=", value, "cancelStatus");
            return (Criteria) this;
        }

        public Criteria andCancelStatusGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CancelStatus >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelStatusLessThan(Integer value) {
            addCriterion("discountorder.CancelStatus <", value, "cancelStatus");
            return (Criteria) this;
        }

        public Criteria andCancelStatusLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CancelStatus < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelStatusLessThanOrEqualTo(Integer value) {
            addCriterion("discountorder.CancelStatus <=", value, "cancelStatus");
            return (Criteria) this;
        }

        public Criteria andCancelStatusLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CancelStatus <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCancelStatusIn(List<Integer> values) {
            addCriterion("discountorder.CancelStatus in", values, "cancelStatus");
            return (Criteria) this;
        }

        public Criteria andCancelStatusNotIn(List<Integer> values) {
            addCriterion("discountorder.CancelStatus not in", values, "cancelStatus");
            return (Criteria) this;
        }

        public Criteria andCancelStatusBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.CancelStatus between", value1, value2, "cancelStatus");
            return (Criteria) this;
        }

        public Criteria andCancelStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.CancelStatus not between", value1, value2, "cancelStatus");
            return (Criteria) this;
        }

        public Criteria andProcessStatusIsNull() {
            addCriterion("discountorder.ProcessStatus is null");
            return (Criteria) this;
        }

        public Criteria andProcessStatusIsNotNull() {
            addCriterion("discountorder.ProcessStatus is not null");
            return (Criteria) this;
        }

        public Criteria andProcessStatusEqualTo(Integer value) {
            addCriterion("discountorder.ProcessStatus =", value, "processStatus");
            return (Criteria) this;
        }

        public Criteria andProcessStatusEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProcessStatus = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProcessStatusNotEqualTo(Integer value) {
            addCriterion("discountorder.ProcessStatus <>", value, "processStatus");
            return (Criteria) this;
        }

        public Criteria andProcessStatusNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProcessStatus <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProcessStatusGreaterThan(Integer value) {
            addCriterion("discountorder.ProcessStatus >", value, "processStatus");
            return (Criteria) this;
        }

        public Criteria andProcessStatusGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProcessStatus > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProcessStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountorder.ProcessStatus >=", value, "processStatus");
            return (Criteria) this;
        }

        public Criteria andProcessStatusGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProcessStatus >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProcessStatusLessThan(Integer value) {
            addCriterion("discountorder.ProcessStatus <", value, "processStatus");
            return (Criteria) this;
        }

        public Criteria andProcessStatusLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProcessStatus < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProcessStatusLessThanOrEqualTo(Integer value) {
            addCriterion("discountorder.ProcessStatus <=", value, "processStatus");
            return (Criteria) this;
        }

        public Criteria andProcessStatusLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProcessStatus <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProcessStatusIn(List<Integer> values) {
            addCriterion("discountorder.ProcessStatus in", values, "processStatus");
            return (Criteria) this;
        }

        public Criteria andProcessStatusNotIn(List<Integer> values) {
            addCriterion("discountorder.ProcessStatus not in", values, "processStatus");
            return (Criteria) this;
        }

        public Criteria andProcessStatusBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.ProcessStatus between", value1, value2, "processStatus");
            return (Criteria) this;
        }

        public Criteria andProcessStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.ProcessStatus not between", value1, value2, "processStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusIsNull() {
            addCriterion("discountorder.RefundStatus is null");
            return (Criteria) this;
        }

        public Criteria andRefundStatusIsNotNull() {
            addCriterion("discountorder.RefundStatus is not null");
            return (Criteria) this;
        }

        public Criteria andRefundStatusEqualTo(Integer value) {
            addCriterion("discountorder.RefundStatus =", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RefundStatus = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotEqualTo(Integer value) {
            addCriterion("discountorder.RefundStatus <>", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RefundStatus <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRefundStatusGreaterThan(Integer value) {
            addCriterion("discountorder.RefundStatus >", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RefundStatus > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRefundStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountorder.RefundStatus >=", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RefundStatus >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRefundStatusLessThan(Integer value) {
            addCriterion("discountorder.RefundStatus <", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RefundStatus < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRefundStatusLessThanOrEqualTo(Integer value) {
            addCriterion("discountorder.RefundStatus <=", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.RefundStatus <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRefundStatusIn(List<Integer> values) {
            addCriterion("discountorder.RefundStatus in", values, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotIn(List<Integer> values) {
            addCriterion("discountorder.RefundStatus not in", values, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.RefundStatus between", value1, value2, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.RefundStatus not between", value1, value2, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andCompleteStatusIsNull() {
            addCriterion("discountorder.CompleteStatus is null");
            return (Criteria) this;
        }

        public Criteria andCompleteStatusIsNotNull() {
            addCriterion("discountorder.CompleteStatus is not null");
            return (Criteria) this;
        }

        public Criteria andCompleteStatusEqualTo(Integer value) {
            addCriterion("discountorder.CompleteStatus =", value, "completeStatus");
            return (Criteria) this;
        }

        public Criteria andCompleteStatusEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CompleteStatus = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCompleteStatusNotEqualTo(Integer value) {
            addCriterion("discountorder.CompleteStatus <>", value, "completeStatus");
            return (Criteria) this;
        }

        public Criteria andCompleteStatusNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CompleteStatus <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCompleteStatusGreaterThan(Integer value) {
            addCriterion("discountorder.CompleteStatus >", value, "completeStatus");
            return (Criteria) this;
        }

        public Criteria andCompleteStatusGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CompleteStatus > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCompleteStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountorder.CompleteStatus >=", value, "completeStatus");
            return (Criteria) this;
        }

        public Criteria andCompleteStatusGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CompleteStatus >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCompleteStatusLessThan(Integer value) {
            addCriterion("discountorder.CompleteStatus <", value, "completeStatus");
            return (Criteria) this;
        }

        public Criteria andCompleteStatusLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CompleteStatus < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCompleteStatusLessThanOrEqualTo(Integer value) {
            addCriterion("discountorder.CompleteStatus <=", value, "completeStatus");
            return (Criteria) this;
        }

        public Criteria andCompleteStatusLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CompleteStatus <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCompleteStatusIn(List<Integer> values) {
            addCriterion("discountorder.CompleteStatus in", values, "completeStatus");
            return (Criteria) this;
        }

        public Criteria andCompleteStatusNotIn(List<Integer> values) {
            addCriterion("discountorder.CompleteStatus not in", values, "completeStatus");
            return (Criteria) this;
        }

        public Criteria andCompleteStatusBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.CompleteStatus between", value1, value2, "completeStatus");
            return (Criteria) this;
        }

        public Criteria andCompleteStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("discountorder.CompleteStatus not between", value1, value2, "completeStatus");
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonIsNull() {
            addCriterion("discountorder.ProcessFailedReason is null");
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonIsNotNull() {
            addCriterion("discountorder.ProcessFailedReason is not null");
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonEqualTo(String value) {
            addCriterion("discountorder.ProcessFailedReason =", value, "processFailedReason");
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProcessFailedReason = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonNotEqualTo(String value) {
            addCriterion("discountorder.ProcessFailedReason <>", value, "processFailedReason");
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProcessFailedReason <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonGreaterThan(String value) {
            addCriterion("discountorder.ProcessFailedReason >", value, "processFailedReason");
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProcessFailedReason > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonGreaterThanOrEqualTo(String value) {
            addCriterion("discountorder.ProcessFailedReason >=", value, "processFailedReason");
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProcessFailedReason >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonLessThan(String value) {
            addCriterion("discountorder.ProcessFailedReason <", value, "processFailedReason");
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProcessFailedReason < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonLessThanOrEqualTo(String value) {
            addCriterion("discountorder.ProcessFailedReason <=", value, "processFailedReason");
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.ProcessFailedReason <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonLike(String value) {
            addCriterion("discountorder.ProcessFailedReason like", value, "processFailedReason");
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonNotLike(String value) {
            addCriterion("discountorder.ProcessFailedReason not like", value, "processFailedReason");
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonIn(List<String> values) {
            addCriterion("discountorder.ProcessFailedReason in", values, "processFailedReason");
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonNotIn(List<String> values) {
            addCriterion("discountorder.ProcessFailedReason not in", values, "processFailedReason");
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonBetween(String value1, String value2) {
            addCriterion("discountorder.ProcessFailedReason between", value1, value2, "processFailedReason");
            return (Criteria) this;
        }

        public Criteria andProcessFailedReasonNotBetween(String value1, String value2) {
            addCriterion("discountorder.ProcessFailedReason not between", value1, value2, "processFailedReason");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("discountorder.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("discountorder.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("discountorder.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("discountorder.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("discountorder.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("discountorder.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("discountorder.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("discountorder.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("discountorder.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("discountorder.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("discountorder.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("discountorder.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("discountorder.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("discountorder.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("discountorder.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("discountorder.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("discountorder.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("discountorder.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("discountorder.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("discountorder.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("discountorder.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("discountorder.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("discountorder.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("discountorder.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("discountorder.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("discountorder.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("discountorder.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("discountorder.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("discountorder.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("discountorder.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("discountorder.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("discountorder.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("discountorder.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("discountorder.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("discountorder.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("discountorder.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("discountorder.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("discountorder.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("discountorder.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("discountorder.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("discountorder.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("discountorder.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("discountorder.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("discountorder.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("discountorder.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("discountorder.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("discountorder.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("discountorder.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("discountorder.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("discountorder.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("discountorder.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("discountorder.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("discountorder.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("discountorder.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("discountorder.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("discountorder.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("discountorder.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("discountorder.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("discountorder.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("discountorder.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(DiscountOrder.Column column) {
            addCriterion(new StringBuilder("discountorder.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("discountorder.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("discountorder.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("discountorder.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("discountorder.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private DiscountOrderExample example;

        protected Criteria(DiscountOrderExample example) {
            super();
            this.example = example;
        }

        public DiscountOrderExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(DiscountOrder.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(DiscountOrder.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.discount.sales.entity.DiscountOrderExample example);
    }
}